import xlwings as xw

wb = xw.Book()
sht = wb.sheets.active
for i in range(1, 6):
    for j in range(1, 6):
        sht.range(i, j).value = '({}, {})'.format(i, j)
print(sht.range((1, 1), (5, 5)).expand().value)  # 批量读取
print(sht.range(2, 2).expand('right').value)  # 按行读
print(sht.range(3, 3).expand('down').value)  # 按列读
input('Enter to quit')
wb.close()
